Report Zillow

Dataset statistics

Number of variables	29
Number of observations	12532
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.7 MiB
Average record size in memory	225.0 B

Variable types

NUM	15
CAT	12
BOOL	2

Warnings

`sewer` has a high cardinality: 100 distinct values	High cardinality
`water` has a high cardinality: 73 distinct values	High cardinality
`app` has a high cardinality: 146 distinct values	High cardinality
`heating` has a high cardinality: 89 distinct values	High cardinality
`cooling` has a high cardinality: 115 distinct values	High cardinality
`materials` has a high cardinality: 156 distinct values	High cardinality
`roof` has a high cardinality: 272 distinct values	High cardinality
`interior` has a high cardinality: 439 distinct values	High cardinality
`bed` is highly correlated with `bath`	High correlation
`bath` is highly correlated with `bed`	High correlation
`total_spaces` is highly skewed (γ1 = 60.01606963)	Skewed
`year` is highly skewed (γ1 = 35.77358096)	Skewed
`df_index` has unique values	Unique
`living` has 148 (1.2%) zeros	Zeros
`lot_a` has 809 (6.5%) zeros	Zeros
`tax_assessed` has 537 (4.3%) zeros	Zeros
`stories` has 1356 (10.8%) zeros	Zeros

Reproduction

Analysis started	2023-02-08 03:05:18.187470
Analysis finished	2023-02-08 03:05:36.854358
Duration	18.67 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	12532
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6768.654325
Minimum	0
Maximum	13337
Zeros	1
Zeros (%)	< 0.1%
Memory size	97.9 KiB

Quantile statistics

Minimum	0
5-th percentile	718.55
Q1	3524.75
median	6814.5
Q3	10022.25
95-th percentile	12678.9
Maximum	13337
Range	13337
Interquartile range (IQR)	6497.5

Descriptive statistics

Standard deviation	3796.310452
Coefficient of variation (CV)	0.5608663509
Kurtosis	-1.172766567
Mean	6768.654325
Median Absolute Deviation (MAD)	3249.5
Skewness	-0.02047716525
Sum	84824776
Variance	14411973.05
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
8865	1	< 0.1%
4743	1	< 0.1%
10888	1	< 0.1%
8841	1	< 0.1%
12939	1	< 0.1%
2700	1	< 0.1%
6798	1	< 0.1%
4751	1	< 0.1%
10896	1	< 0.1%
Other values (12522)	12522	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
5	1	< 0.1%

Value	Count	Frequency (%)
13337	1	< 0.1%
13336	1	< 0.1%
13335	1	< 0.1%
13334	1	< 0.1%
13333	1	< 0.1%

price
Real number (ℝ_≥0)

Distinct	2325
Distinct (%)	18.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	718536.1905
Minimum	0
Maximum	4000000
Zeros	2
Zeros (%)	< 0.1%
Memory size	97.9 KiB

Quantile statistics

Minimum	0
5-th percentile	165000
Q1	299900
median	484500
Q3	875000
95-th percentile	2150000
Maximum	4000000
Range	4000000
Interquartile range (IQR)	575100

Descriptive statistics

Standard deviation	654363.5506
Coefficient of variation (CV)	0.9106897596
Kurtosis	5.214117613
Mean	718536.1905
Median Absolute Deviation (MAD)	219875
Skewness	2.156878253
Sum	9004695539
Variance	4.281916563e+11
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
350000	119	0.9%
325000	84	0.7%
299900	84	0.7%
650000	80	0.6%
375000	79	0.6%
399900	78	0.6%
450000	76	0.6%
399000	74	0.6%
300000	73	0.6%
275000	72	0.6%
Other values (2315)	11713	93.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	< 0.1%
19900	1	< 0.1%
30000	2	< 0.1%
32900	1	< 0.1%
35000	1	< 0.1%

Value	Count	Frequency (%)
4000000	2	< 0.1%
3999999	3	< 0.1%
3999000	3	< 0.1%
3998000	1	< 0.1%
3995000	12	0.1%

status
Categorical

Distinct	9
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	97.9 KiB

House for sale	9924
Active	1770
New construction	514
New	158
Foreclosure	66
Other values (4)	100

Frequencies
Length

Value	Count	Frequency (%)
House for sale	9924	79.2%
Active	1770	14.1%
New construction	514	4.1%
New	158	1.3%
Foreclosure	66	0.5%
Price Change	45	0.4%
Coming soon	41	0.3%
Auction	9	0.1%
Re-activated	5	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	16
Median length	14
Mean length	12.77481647
Min length	3

add_attr
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.2 KiB

True	9551
False	2981

Common Values
Chart

Value	Count	Frequency (%)
True	9551	76.2%
False	2981	23.8%

state
Categorical

Distinct	14
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	97.9 KiB

TX	3231
CA	1778
OH	752
AZ	751
IN	739
Other values (9)	5281

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
TX	3231	25.8%
CA	1778	14.2%
OH	752	6.0%
AZ	751	6.0%
IN	739	5.9%
PA	738	5.9%
FL	722	5.8%
NC	715	5.7%
IL	711	5.7%
TN	644	5.1%
Other values (4)	1751	14.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	2
Median length	2
Mean length	2
Min length	2

lat
Real number (ℝ_≥0)

Distinct	12418
Distinct (%)	99.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	35.79885016
Minimum	0
Maximum	47.733967
Zeros	1
Zeros (%)	< 0.1%
Memory size	97.9 KiB

Quantile statistics

Minimum	0
5-th percentile	29.5874241
Q1	32.73549675
median	35.1891405
Q3	39.89418175
95-th percentile	41.9061163
Maximum	47.733967
Range	47.733967
Interquartile range (IQR)	7.158685

Descriptive statistics

Standard deviation	4.442612396
Coefficient of variation (CV)	0.1240993042
Kurtosis	-0.3488390997
Mean	35.79885016
Median Absolute Deviation (MAD)	4.5767115
Skewness	0.2716118883
Sum	448631.1902
Variance	19.7368049
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.015083	3	< 0.1%
34.157944	2	< 0.1%
39.685493	2	< 0.1%
39.95862	2	< 0.1%
40.029507	2	< 0.1%
32.815533	2	< 0.1%
32.737553	2	< 0.1%
29.602264	2	< 0.1%
39.94828	2	< 0.1%
39.981464	2	< 0.1%
Other values (12408)	12511	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
29.138699	1	< 0.1%
29.1487	1	< 0.1%
29.166689	1	< 0.1%
29.198627	1	< 0.1%

Value	Count	Frequency (%)
47.733967	1	< 0.1%
47.733162	1	< 0.1%
47.732807	1	< 0.1%
47.731823	1	< 0.1%
47.73067	1	< 0.1%

long
Real number (ℝ)

Distinct	12392
Distinct (%)	98.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-94.85075051
Minimum	-122.508575
Maximum	0
Zeros	1
Zeros (%)	< 0.1%
Memory size	97.9 KiB

Quantile statistics

Minimum	-122.508575
5-th percentile	-121.9051895
Q1	-104.939925
median	-95.430715
Q3	-82.9066975
95-th percentile	-75.0105505
Maximum	0
Range	122.508575
Interquartile range (IQR)	22.0332275

Descriptive statistics

Standard deviation	14.76865219
Coefficient of variation (CV)	-0.1557041153
Kurtosis	-0.8306255116
Mean	-94.85075051
Median Absolute Deviation (MAD)	12.44971
Skewness	-0.4221282019
Sum	-1188669.605
Variance	218.1130877
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-87.67369	2	< 0.1%
-83.00427	2	< 0.1%
-82.99444	2	< 0.1%
-80.84424	2	< 0.1%
-73.80169	2	< 0.1%
-97.37365	2	< 0.1%
-76.93597	2	< 0.1%
-98.657425	2	< 0.1%
-98.65886	2	< 0.1%
-96.67444	2	< 0.1%
Other values (12382)	12512	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-122.508575	1	< 0.1%
-122.50841	1	< 0.1%
-122.50772	1	< 0.1%
-122.50759	1	< 0.1%
-122.50677	1	< 0.1%

Value	Count	Frequency (%)
0	1	< 0.1%
-73.7041	1	< 0.1%
-73.704544	1	< 0.1%
-73.70573	1	< 0.1%
-73.70951	1	< 0.1%

bath
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.538142356
Minimum	1.5
Maximum	5.5
Zeros	0
Zeros (%)	0.0%
Memory size	97.9 KiB

Quantile statistics

Minimum	1.5
5-th percentile	2
Q1	3
median	3
Q3	4
95-th percentile	5
Maximum	5.5
Range	4
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.8839703363
Coefficient of variation (CV)	0.2498402403
Kurtosis	-0.3372601497
Mean	3.538142356
Median Absolute Deviation (MAD)	1
Skewness	0.2686958455
Sum	44340
Variance	0.7814035555
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
3	5413	43.2%
4	4225	33.7%
5	1325	10.6%
2	1061	8.5%
5.5	423	3.4%
1.5	85	0.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.5	85	0.7%
2	1061	8.5%
3	5413	43.2%
4	4225	33.7%
5	1325	10.6%

Value	Count	Frequency (%)
5.5	423	3.4%
5	1325	10.6%
4	4225	33.7%
3	5413	43.2%
2	1061	8.5%

bed
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	14
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.563517395
Minimum	0
Maximum	14
Zeros	16
Zeros (%)	0.1%
Memory size	97.9 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	3
median	3
Q3	4
95-th percentile	5
Maximum	14
Range	14
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.9903548966
Coefficient of variation (CV)	0.2779149887
Kurtosis	4.449020147
Mean	3.563517395
Median Absolute Deviation (MAD)	1
Skewness	0.9733658236
Sum	44658
Variance	0.9808028213
Monotocity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
3	5413	43.2%
4	4225	33.7%
5	1325	10.6%
2	1061	8.5%
6	328	2.6%
1	69	0.6%
7	63	0.5%
8	17	0.1%
0	16	0.1%
9	4	< 0.1%
Other values (4)	11	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	16	0.1%
1	69	0.6%
2	1061	8.5%
3	5413	43.2%
4	4225	33.7%

Value	Count	Frequency (%)
14	1	< 0.1%
12	2	< 0.1%
11	4	< 0.1%
10	4	< 0.1%
9	4	< 0.1%

living
Real number (ℝ_≥0)

ZEROS

Distinct	3510
Distinct (%)	28.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2131.440233
Minimum	0
Maximum	8000
Zeros	148
Zeros (%)	1.2%
Memory size	97.9 KiB

Quantile statistics

Minimum	0
5-th percentile	918
Q1	1384
median	1885.5
Q3	2600
95-th percentile	4260.45
Maximum	8000
Range	8000
Interquartile range (IQR)	1216

Descriptive statistics

Standard deviation	1087.33886
Coefficient of variation (CV)	0.5101427867
Kurtosis	3.093274666
Mean	2131.440233
Median Absolute Deviation (MAD)	576.5
Skewness	1.433336968
Sum	26711209
Variance	1182305.797
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	148	1.2%
1200	59	0.5%
1800	42	0.3%
2000	40	0.3%
3000	38	0.3%
1600	38	0.3%
1440	37	0.3%
1500	37	0.3%
2200	35	0.3%
2100	33	0.3%
Other values (3500)	12025	96.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	148	1.2%
1	2	< 0.1%
300	1	< 0.1%
392	1	< 0.1%
400	1	< 0.1%

Value	Count	Frequency (%)
8000	2	< 0.1%
7980	1	< 0.1%
7921	1	< 0.1%
7815	1	< 0.1%
7739	1	< 0.1%

lot_a
Real number (ℝ_≥0)

ZEROS

Distinct	4110
Distinct (%)	32.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4301.277688
Minimum	0
Maximum	10846.44
Zeros	809
Zeros (%)	6.5%
Memory size	97.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3.48
median	4647.852
Q3	6969.6
95-th percentile	9583.2
Maximum	10846.44
Range	10846.44
Interquartile range (IQR)	6966.12

Descriptive statistics

Standard deviation	3279.932024
Coefficient of variation (CV)	0.7625483083
Kurtosis	-1.225198237
Mean	4301.277688
Median Absolute Deviation (MAD)	2757.348
Skewness	0.04332859187
Sum	53903611.98
Variance	10757954.08
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	809	6.5%
7405.2	141	1.1%
6534	139	1.1%
6098.4	135	1.1%
4791.6	129	1.0%
5227.2	123	1.0%
7840.8	118	0.9%
4356	115	0.9%
8276.4	108	0.9%
10018.8	108	0.9%
Other values (4100)	10607	84.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	809	6.5%
0.13	1	< 0.1%
0.146	1	< 0.1%
0.172	1	< 0.1%
0.21	1	< 0.1%

Value	Count	Frequency (%)
10846.44	1	< 0.1%
10846	1	< 0.1%
10837.728	1	< 0.1%
10833.372	1	< 0.1%
10815.948	1	< 0.1%

tax_assessed
Real number (ℝ_≥0)

ZEROS

Distinct	9715
Distinct (%)	77.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	394814.7968
Minimum	0
Maximum	2499000
Zeros	537
Zeros (%)	4.3%
Memory size	97.9 KiB

Quantile statistics

Minimum	0
5-th percentile	14071.65
Q1	155000
median	272803.5
Q3	513050
95-th percentile	1213995.25
Maximum	2499000
Range	2499000
Interquartile range (IQR)	358050

Descriptive statistics

Standard deviation	383177.391
Coefficient of variation (CV)	0.9705243932
Kurtosis	5.34894722
Mean	394814.7968
Median Absolute Deviation (MAD)	153030.5
Skewness	2.093016321
Sum	4947819033
Variance	1.46824913e+11
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	537	4.3%
5000	18	0.1%
195000	8	0.1%
45000	8	0.1%
360000	7	0.1%
205000	7	0.1%
230000	7	0.1%
610000	6	< 0.1%
35000	6	< 0.1%
260000	6	< 0.1%
Other values (9705)	11922	95.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	537	4.3%
100	1	< 0.1%
200	1	< 0.1%
495	1	< 0.1%
700	1	< 0.1%

Value	Count	Frequency (%)
2499000	1	< 0.1%
2485330	1	< 0.1%
2475421	1	< 0.1%
2466063	1	< 0.1%
2465060	1	< 0.1%

fireplace
Real number (ℝ_≥0)

Distinct	9
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.125279285
Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Memory size	97.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	9
Range	8
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.5070181404
Coefficient of variation (CV)	0.4505709357
Kurtosis	46.76316355
Mean	1.125279285
Median Absolute Deviation (MAD)	0
Skewness	5.907319112
Sum	14102
Variance	0.2570673947
Monotocity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
1	11507	91.8%
2	702	5.6%
3	198	1.6%
4	65	0.5%
5	39	0.3%
6	10	0.1%
7	8	0.1%
9	2	< 0.1%
8	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	11507	91.8%
2	702	5.6%
3	198	1.6%
4	65	0.5%
5	39	0.3%

Value	Count	Frequency (%)
9	2	< 0.1%
8	1	< 0.1%
7	8	0.1%
6	10	0.1%
5	39	0.3%

parking
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	97.9 KiB

1	12184
0	348

Common Values
Chart

Value	Count	Frequency (%)
1	12184	97.2%
0	348	2.8%

covered
Real number (ℝ_≥0)

Distinct	291
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.924721884
Minimum	1
Maximum	5
Zeros	0
Zeros (%)	0.0%
Memory size	97.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1.76
median	2
Q3	2
95-th percentile	3
Maximum	5
Range	4
Interquartile range (IQR)	0.24

Descriptive statistics

Standard deviation	0.5606160541
Coefficient of variation (CV)	0.2912712007
Kurtosis	5.649138899
Mean	1.924721884
Median Absolute Deviation (MAD)	0.045
Skewness	1.368775142
Sum	24120.61465
Variance	0.3142903601
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	5575	44.5%
1	1609	12.8%
3	779	6.2%
4	207	1.7%
1.72	109	0.9%
1.75	93	0.7%
1.82	92	0.7%
1.65	91	0.7%
1.975	90	0.7%
1.995	88	0.7%
Other values (281)	3799	30.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1609	12.8%
1.045	1	< 0.1%
1.085	3	< 0.1%
1.135	1	< 0.1%
1.14	4	< 0.1%

Value	Count	Frequency (%)
5	51	0.4%
4	207	1.7%
3.5	3	< 0.1%
3.34	1	< 0.1%
3.145	1	< 0.1%

garage
Real number (ℝ_≥0)

Distinct	240
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.876448182
Minimum	1.3125
Maximum	2.4125
Zeros	0
Zeros (%)	0.0%
Memory size	97.9 KiB

Quantile statistics

Minimum	1.3125
5-th percentile	1.3125
Q1	1.725
median	2
Q3	2
95-th percentile	2.4125
Maximum	2.4125
Range	1.1
Interquartile range (IQR)	0.275

Descriptive statistics

Standard deviation	0.2956233863
Coefficient of variation (CV)	0.1575441247
Kurtosis	-0.09521204028
Mean	1.876448182
Median Absolute Deviation (MAD)	0.055
Skewness	-0.4949913579
Sum	23515.64861
Variance	0.08739318652
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	5527	44.1%
1.3125	1654	13.2%
2.4125	1067	8.5%
1.685	109	0.9%
1.625	103	0.8%
1.945	99	0.8%
1.985	97	0.8%
1.78	91	0.7%
1.54	90	0.7%
1.925	88	0.7%
Other values (230)	3607	28.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.3125	1654	13.2%
1.315	3	< 0.1%
1.32	13	0.1%
1.33	1	< 0.1%
1.335	6	< 0.1%

Value	Count	Frequency (%)
2.4125	1067	8.5%
2.405	1	< 0.1%
2.395	2	< 0.1%
2.38	1	< 0.1%
2.375	1	< 0.1%

total_spaces
Real number (ℝ_≥0)

SKEWED

Distinct	296
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.345138771
Minimum	1
Maximum	212
Zeros	0
Zeros (%)	0.0%
Memory size	97.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	2.32
95-th percentile	4
Maximum	212
Range	211
Interquartile range (IQR)	0.32

Descriptive statistics

Standard deviation	2.848027562
Coefficient of variation (CV)	1.21443882
Kurtosis	4309.804419
Mean	2.345138771
Median Absolute Deviation (MAD)	0.095
Skewness	60.01606963
Sum	29389.27908
Variance	8.111260992
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	5384	43.0%
1	1633	13.0%
3	930	7.4%
4	819	6.5%
6	207	1.7%
5	181	1.4%
2.175	124	1.0%
2.01	73	0.6%
2.52	71	0.6%
1.85	64	0.5%
Other values (286)	3046	24.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1633	13.0%
1.355	1	< 0.1%
1.395	3	< 0.1%
1.47	1	< 0.1%
1.485	6	< 0.1%

Value	Count	Frequency (%)
212	1	< 0.1%
203	1	< 0.1%
25	1	< 0.1%
21	1	< 0.1%
20	1	< 0.1%

subtype
Categorical

Distinct	26
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	97.9 KiB

Single Family Residence	10293
Residentia	974
Detached	459
none	322
Residential	202
Other values (21)	282

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Single Family Residence	10293	82.1%
Residentia	974	7.8%
Detached	459	3.7%
none	322	2.6%
Residential	202	1.6%
Single Family - Detached	116	0.9%
Ranch	41	0.3%
All Other Attached	33	0.3%
Single Family - Semi-Attached	23	0.2%
Residential-Detache	13	0.1%
Other values (16)	56	0.4%

Frequencies of value counts

Unique

Unique	5 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	29
Median length	23
Mean length	20.67299713
Min length	4

year
Real number (ℝ_≥0)

SKEWED

Distinct	196
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1965.777867
Minimum	0
Maximum	9999
Zeros	15
Zeros (%)	0.1%
Memory size	97.9 KiB

Quantile statistics

Minimum	0
5-th percentile	1906
Q1	1941
median	1966
Q3	1998
95-th percentile	2022
Maximum	9999
Range	9999
Interquartile range (IQR)	57

Descriptive statistics

Standard deviation	127.2147766
Coefficient of variation (CV)	0.06471472628
Kurtosis	2604.285844
Mean	1965.777867
Median Absolute Deviation (MAD)	28
Skewness	35.77358096
Sum	24635128.22
Variance	16183.59938
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2022	607	4.8%
1925	323	2.6%
1950	267	2.1%
1920	244	1.9%
1955	223	1.8%
1900	218	1.7%
1940	202	1.6%
2006	202	1.6%
2005	190	1.5%
1960	189	1.5%
Other values (186)	9867	78.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	15	0.1%
1730	1	< 0.1%
1750	1	< 0.1%
1807	1	< 0.1%
1830	1	< 0.1%

Value	Count	Frequency (%)
9999	2	< 0.1%
2023	64	0.5%
2022	607	4.8%
2021.95	7	0.1%
2021	68	0.5%

sewer
Categorical

HIGH CARDINALITY

Distinct	100
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	97.9 KiB

Public Sewer	6954
none	2245
City Sewer	1364
Sewer Connecte	430
SAW	201
Other values (95)	1338

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Public Sewer	6954	55.5%
none	2245	17.9%
City Sewer	1364	10.9%
Sewer Connecte	430	3.4%
SAW	201	1.6%
Sewer System	180	1.4%
Septic System	117	0.9%
Septic Tank	113	0.9%
Sewer Connected	102	0.8%
SAWS	101	0.8%
Other values (90)	725	5.8%

Frequencies of value counts

Unique

Unique	29 ?
Unique (%)	0.2%

Histogram of lengths of the category

Length

Max length	32
Median length	12
Mean length	10.23068944
Min length	1

water
Categorical

HIGH CARDINALITY

Distinct	73
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	97.9 KiB

Public	6599
none	1896
City Water	1049
Publi	530
Lake Michigan	363
Other values (68)	2095

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Public	6599	52.7%
none	1896	15.1%
City Water	1049	8.4%
Publi	530	4.2%
Lake Michigan	363	2.9%
Meter on Property	348	2.8%
City Wate	306	2.4%
SAW	262	2.1%
Water System	199	1.6%
Water District	159	1.3%
Other values (63)	821	6.6%

Frequencies of value counts

Unique

Unique	25 ?
Unique (%)	0.2%

Histogram of lengths of the category

Length

Max length	32
Median length	6
Mean length	7.038860517
Min length	3

app
Categorical

HIGH CARDINALITY

Distinct	146
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Memory size	97.9 KiB

dishwasher	4734
none	1669
electric water heater	542
gas water heater	537
built-in microwave	529
Other values (141)	4521

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
dishwasher	4734	37.8%
none	1669	13.3%
electric water heater	542	4.3%
gas water heater	537	4.3%
built-in microwave	529	4.2%
range	515	4.1%
cooktop	296	2.4%
electric cooktop	284	2.3%
gas cooktop	256	2.0%
dryer	242	1.9%
Other values (136)	2928	23.4%

Frequencies of value counts

Unique

Unique	36 ?
Unique (%)	0.3%

Histogram of lengths of the category

Length

Max length	38
Median length	10
Mean length	10.92148101
Min length	3

heating
Categorical

HIGH CARDINALITY

Distinct	89
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	97.9 KiB

central	4421
forced air	2737
natural gas	1904
electric	852
none	627
Other values (84)	1991

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
central	4421	35.3%
forced air	2737	21.8%
natural gas	1904	15.2%
electric	852	6.8%
none	627	5.0%
hot water	261	2.1%
fireplace(s	152	1.2%
radiator	141	1.1%
central forced air	125	1.0%
other	117	0.9%
Other values (79)	1195	9.5%

Frequencies of value counts

Unique

Unique	21 ?
Unique (%)	0.2%

Histogram of lengths of the category

Length

Max length	31
Median length	8
Mean length	8.913501436
Min length	2

cooling
Categorical

HIGH CARDINALITY

Distinct	115
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	97.9 KiB

Central Air	4531
Ceiling Fan(s	1476
Central Ai	1127
None	790
none	694
Other values (110)	3914

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Central Air	4531	36.2%
Ceiling Fan(s	1476	11.8%
Central Ai	1127	9.0%
None	790	6.3%
none	694	5.5%
Electri	503	4.0%
Central A/	500	4.0%
Electric	388	3.1%
Central Forced Air	275	2.2%
Refrigeration	210	1.7%
Other values (105)	2038	16.3%

Frequencies of value counts

Unique

Unique	23 ?
Unique (%)	0.2%

Histogram of lengths of the category

Length

Max length	31
Median length	11
Mean length	10.39594638
Min length	2

stories
Real number (ℝ_≥0)

ZEROS

Distinct	11
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.488788701
Minimum	0
Maximum	7
Zeros	1356
Zeros (%)	10.8%
Memory size	97.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	2
95-th percentile	3
Maximum	7
Range	7
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.8473448893
Coefficient of variation (CV)	0.5691505375
Kurtosis	0.1737491559
Mean	1.488788701
Median Absolute Deviation (MAD)	1
Skewness	0.258347578
Sum	18657.5
Variance	0.7179933615
Monotocity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
1	5114	40.8%
2	4714	37.6%
0	1356	10.8%
3	1016	8.1%
3.5	135	1.1%
2.5	91	0.7%
4	73	0.6%
1.5	27	0.2%
5	3	< 0.1%
7	2	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1356	10.8%
1	5114	40.8%
1.5	27	0.2%
2	4714	37.6%
2.5	91	0.7%

Value	Count	Frequency (%)
7	2	< 0.1%
6	1	< 0.1%
5	3	< 0.1%
4	73	0.6%
3.5	135	1.1%

materials
Categorical

HIGH CARDINALITY

Distinct	156
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Memory size	97.9 KiB

brick	3996
none	1793
stucco	721
vinyl sideing	618
frame	508
Other values (151)	4896

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
brick	3996	31.9%
none	1793	14.3%
stucco	721	5.8%
vinyl sideing	618	4.9%
frame	508	4.1%
masonry	469	3.7%
wood sideing	392	3.1%
frame - woo	374	3.0%
stone	347	2.8%
block	331	2.6%
Other values (146)	2983	23.8%

Frequencies of value counts

Unique

Unique	45 ?
Unique (%)	0.4%

Histogram of lengths of the category

Length

Max length	30
Median length	5
Mean length	7.320699011
Min length	3

roof
Categorical

HIGH CARDINALITY

Distinct	272
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Memory size	97.9 KiB

none	4058
Composition	3980
Shingle	1308
Tile	519
Asphalt	431
Other values (267)	2236

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
none	4058	32.4%
Composition	3980	31.8%
Shingle	1308	10.4%
Tile	519	4.1%
Asphalt	431	3.4%
Comp Shingle	281	2.2%
Metal	182	1.5%
Other	172	1.4%
Composition,Shingle	140	1.1%
Flat	139	1.1%
Other values (262)	1322	10.5%

Frequencies of value counts

Unique

Unique	138 ?
Unique (%)	1.1%

Histogram of lengths of the category

Length

Max length	57
Median length	7
Mean length	8.150734121
Min length	4

foundation
Categorical

Distinct	49
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	97.9 KiB

none	5388
slab	3543
concrete perimeter	676
crawl space	462
pillar/post/pier	462
Other values (44)	2001

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
none	5388	43.0%
slab	3543	28.3%
concrete perimeter	676	5.4%
crawl space	462	3.7%
pillar/post/pier	462	3.7%
poured concrete	441	3.5%
blogck	306	2.4%
other	223	1.8%
stone	159	1.3%
brick/mortar	157	1.3%
Other values (39)	715	5.7%

Frequencies of value counts

Unique

Unique	11 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	27
Median length	4
Mean length	6.444861155
Min length	4

interior
Categorical

HIGH CARDINALITY

Distinct	439
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Memory size	97.9 KiB

none	3735
Ceiling Fan(s	559
Cable TV Availabl	553
Built-in Feature	515
One Living Are	358
Other values (434)	6812

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
none	3735	29.8%
Ceiling Fan(s	559	4.5%
Cable TV Availabl	553	4.4%
Built-in Feature	515	4.1%
One Living Are	358	2.9%
Walk-In Closet(s	316	2.5%
Breakfast Ba	243	1.9%
Two Living Are	239	1.9%
High Ceiling	227	1.8%
Walk-In Closet(s)	219	1.7%
Other values (429)	5568	44.4%

Frequencies of value counts

Unique

Unique	186 ?
Unique (%)	1.5%

Histogram of lengths of the category

Length

Max length	38
Median length	13
Mean length	11.40025535
Min length	2

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

First rows

	df_index	price	status	add_attr	state	lat	long	bath	bed	living	lot_a	tax_assessed	fireplace	parking	covered	garage	total_spaces	subtype	year	sewer	water	app	heating	cooling	stories	materials	roof	foundation	interior
0	0	274000	House for sale	True	NY	40.675730	-73.822350	3.0	3	1556	2400.0	0	1.0	1.0	1.750	1.5950	1.945	none	1930.0	none	none	none	none	none	0.0	none	none	none	none
1	1	270000	House for sale	True	NY	40.670036	-73.780450	4.0	4	1920	3998.0	678000	1.0	1.0	1.660	1.5350	2.160	none	1950.0	none	none	microwave	none	none	0.0	none	none	none	none
2	2	899000	House for sale	True	NY	40.524227	-74.215790	3.0	3	2532	6903.0	637000	1.0	1.0	1.935	2.0000	2.000	Single Family - Detached	1899.0	Public Sewer	none	dishwasher	hot water	Units	2.0	none	none	none	none
3	3	1390000	House for sale	True	NY	40.721615	-73.820755	4.0	4	1915	2697.0	894000	1.0	1.0	1.695	1.6550	3.915	none	1945.0	none	none	dryer	none	none	0.0	none	none	none	none
4	5	1380000	House for sale	True	NY	40.604470	-73.943960	3.0	3	1800	2000.0	0	1.0	1.0	1.700	1.3125	2.160	Single Family Residence	1930.0	Public Sewer	Public	dishwasher	natural gas	Wall Unit(s)	2.0	brick	none	none	Formal Dining Roo
5	6	599000	House for sale	True	NY	40.639286	-73.941270	3.0	3	1344	1950.0	534000	1.0	1.0	1.800	1.6850	2.520	none	1925.0	none	none	dryer	none	none	0.0	none	none	none	none
6	7	1280000	House for sale	True	NY	40.622246	-74.017830	3.0	3	1422	2613.0	882000	1.0	1.0	1.605	1.5350	1.000	none	1920.0	none	none	dishwasher	radian	Central	0.0	none	Shake / Shingle	none	none
7	9	899000	House for sale	True	NY	40.578552	-74.005196	4.0	4	2800	3000.0	419000	1.0	1.0	1.720	1.6700	2.000	none	1945.0	none	none	dishwasher	none	none	0.0	none	none	none	none
8	10	565000	House for sale	True	NY	40.682640	-73.788180	3.0	3	1896	1951.0	406000	1.0	1.0	1.800	1.6850	2.520	none	1925.0	none	none	dishwasher	none	none	0.0	none	Shake / Shingle	none	none
9	11	99999	House for sale	True	NY	40.627700	-74.179020	2.0	2	840	2100.0	0	1.0	1.0	2.140	2.1500	3.000	Single Family Residence	1998.0	none	none	none	natural gas	none	1.0	aluminum sidein	Flat,Metal	other	none

Last rows

	df_index	price	status	add_attr	state	lat	long	bath	bed	living	lot_a	tax_assessed	fireplace	parking	covered	garage	total_spaces	subtype	year	sewer	water	app	heating	cooling	stories	materials	roof	foundation	interior
12522	13328	299900	House for sale	True	TN	36.258205	-86.683784	3.0	3	1888	8276.40	181900	1.0	1.0	1.855	1.880	2.145	Single Family Residence	1918.0	Public Sewer	Public	gas water heater	hot water	Central A/	4.0	stucco	none	concrete perimeter	Kitchen - Gourme
12523	13329	385000	House for sale	True	TN	36.158485	-86.828240	3.0	3	1100	0.25	270000	1.0	1.0	1.850	1.850	2.000	Single Family Residence	1925.0	Public Sewer	Public	gas water heater	forced air	Central A/	3.0	aluminum sidein	none	other	none
12524	13330	599000	House for sale	True	TN	36.104990	-86.745760	3.0	3	2532	8712.00	280200	1.0	1.0	1.965	1.955	2.395	Single Family Residence	1976.0	Public Sewer	Public	electric water heater	forced air	Central A/	2.0	brick	none	brick/mortar	none
12525	13331	299000	House for sale	True	TN	36.219044	-86.756760	3.0	3	960	0.41	153300	1.0	0.0	1.915	1.740	2.135	Single Family Residence	1947.0	Public Sewer	Public	oven/range - gas	hot water	Central A/	3.0	brick	Wood,Other	slab	none
12526	13332	1149900	House for sale	True	TN	36.193188	-86.777830	4.0	4	2012	871.20	0	1.0	1.0	1.920	1.780	2.560	Single Family Residence	1936.0	Public Sewer	Public	gas water heater	forced air	None	3.0	brick	none	brick/mortar	Dining Are
12527	13333	3675000	House for sale	True	TN	36.123570	-86.795580	5.0	5	5704	0.29	961800	1.0	1.0	1.905	1.885	2.000	Single Family Residence	1953.0	Public Sewer	Public	built-in microwave	central	Central A/	3.0	brick	Flat	slab	Dining Are
12528	13334	750000	House for sale	True	TN	36.160694	-86.847830	3.0	3	2208	4356.00	563900	1.0	1.0	1.570	1.690	2.030	Single Family Residence	1951.0	Public Sewer	Public	gas water heater	forced air	Central A/	3.0	brick	none	slab	none
12529	13335	575000	House for sale	True	TN	36.204834	-86.738660	4.0	4	3658	9147.60	0	1.0	1.0	1.805	1.780	2.000	Single Family Residence	1940.0	Public Sewer	Public	dishwasher	forced air	Central A/	3.0	brick	none	slab	Kitchen - Gourme
12530	13336	609000	House for sale	True	TN	36.196106	-86.735115	3.0	3	1950	871.20	0	1.0	1.0	1.800	1.685	2.520	Single Family Residence	1925.0	Public Sewer	Public	gas water heater	hot water	Ductless/Mini-Spli	3.0	brick	none	brick/mortar	Ceiling Fan(s)
12531	13337	460000	Coming soon	True	TN	36.026558	-86.717710	3.0	3	2224	7840.80	319600	2.0	1.0	1.895	1.825	2.090	Single Family Residence	1937.0	Public Sewer	Public	built-in microwave	forced air	Central A/	3.0	combination	Unknown	other	Ceiling Fan(s

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows